﻿using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using SubSonic;
using LinFen;
public partial class webUserControl_GetCustomer : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
        int id = 0;
        if(Request["id"]!=null)
        {
            id = int.Parse(Request["id"]);
        }
        SqlQuery q=new SqlQuery();
        q.From("customerinfo");
        q.Where("id").IsEqualTo(id);
        IDataReader dr = q.ExecuteReader();
        if(dr.Read())
        {
            Label1.Text = dr[1].ToString();
            Label2.Text = dr[2].ToString();
            Label3.Text = dr[3].ToString();
            Label4.Text = dr[4].ToString();
            Label5.Text = dr[5].ToString();
            Label6.Text = dr[6].ToString();
            Label7.Text = dr[7].ToString();
            Label8.Text = Convert.ToDateTime(dr[10].ToString()).ToShortDateString();
        }

    }
}
